{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Reference Range Establishment"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Reference Range Establishment","index":0,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,5,43,6],[7,0,7,2],[28,0,28,1],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[43,2,43,4]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 503 (version 1.0). Reference Range Establishment (Hgb)_Example. Page 1 of 1"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"CellDyn Ruby",{"$nulls":4},"Date:","2023-08-03"]
[null,"Analyte",null,"Hemoglobin Female"]
["Reference Range:",null,null,{"$f":"IFERROR(K23,\"\")","v":10.5},"to",{"$f":"IFERROR(J34,\"\")","v":15.9},null,"Units:","g/dL"]
[]
[{"$nulls":8},130]
[]
[15,13,15,14.199999999999999,10.6,15,13,15,30,12.800000000000001,13.6,10.6]
[14.199999999999999,13.6,13,10.9,12,14.199999999999999,13.6,13,8,18,12.800000000000001,12]
[15,12.800000000000001,13.6,13,11.300000000000001,15,12.800000000000001,11.5,13,10.6,12.9,11.300000000000001]
[13,12.5,12.800000000000001,13.6,13,13,15.1,12.800000000000001,13.6,12,10.6,13]
[13.6,10.6,11.9,12.800000000000001,13.6,13.6,10.6,14.800000000000001,12.800000000000001,11.300000000000001,12,13.6]
[12.800000000000001,12,10.6,11.699999999999999,12.800000000000001,12.800000000000001,12,10.6,10.9,12.800000000000001,13.6,12.800000000000001]
[12.6,11.300000000000001,12,10.6,12.800000000000001,13.699999999999999,11.300000000000001,12,10.6,9.5999999999999996,12.800000000000001,14.6]
[10.6,11.6,11.300000000000001,12,10.6,10.6,15.9,11.300000000000001,12,10.6,13.9,10.6]
[12,10.5,12,11.300000000000001,12,12,11.199999999999999,12,11.300000000000001,12,10.6,12]
[11.300000000000001,12.800000000000001,11.800000000000001,12.6,11.300000000000001,11.300000000000001,12,10.6,10.6,11.300000000000001,12,11.300000000000001]
[]
["Mean: ",null,{"$f":"IFERROR(MROUND(AVERAGE(A12:L21),0.01),\"---\")","v":12.5},{"$nulls":5},"Low",null,{"$f":"SMALL(A12:L21,3)","v":10.5},{"$f":"K23-0.01","v":10.49}]
["SD: ",null,{"$f":"IFERROR(MROUND(STDEV(A12:L21),0.01),\"---\")","v":2.1800000000000002},{"$nulls":5},"High",null,{"$f":"SMALL(A12:L21,118)","v":15.9},{"$f":"K24+0.01","v":15.91}]
["Minimum: ",null,{"$f":"MIN(A12:L21)","v":8},{"$nulls":5},"Bin1",{"$f":"L23","v":10.49},{"$f":"K24-K23","v":5.4000000000000004}]
["Maximum: ",null,{"$f":"MAX(A12:L21)","v":30},{"$nulls":5},"Bin2",{"$f":"MROUND(J25+(0.2*K25),0.01)","v":11.57}]
["Median: ",null,{"$f":"IFERROR(MEDIAN(A12:L21),\"---\")","v":12},{"$nulls":5},"Bin3",{"$f":"MROUND($J$25+(0.3*$K$25),0.01)","v":12.109999999999999}]
[{"$nulls":8},"Bin4",{"$f":"MROUND($J$25+(0.4*$K$25),0.01)","v":12.65}]
[{"$f":"I8","v":"g/dL"},null,"Frequency","Percent",{"$nulls":4},"Bin5",{"$f":"MROUND($J$25+(0.5*$K$25),0.01)","v":13.19}]
[{"$f":"\"≤\"&\" \"&J25","v":"≤ 10.49"},null,{"$f":"FREQUENCY(A12:L21,J25:J34)","v":2},{"$f":"C30/120","v":0.016666666666666666},{"$nulls":4},"Bin6",{"$f":"MROUND($J$25+(0.6*$K$25),0.01)","v":13.73}]
[{"$f":"(J25+0.01)&\" \"&\"-\"&\" \"&J26","v":"10.5 - 11.57"},null,37,{"$f":"C31/120","v":0.30833333333333335},{"$nulls":4},"Bin7",{"$f":"MROUND($J$25+(0.7*$K$25),0.01)","v":14.27}]
[{"$f":"(J26+0.01)&\" \"&\"-\"&\" \"&J27","v":"11.58 - 12.11"},null,23,{"$f":"C32/120","v":0.19166666666666668},{"$nulls":4},"Bin8",{"$f":"MROUND($J$25+(0.8*$K$25),0.01)","v":14.81}]
[{"$f":"(J27+0.01)&\" \"&\"-\"&\" \"&J28","v":"12.12 - 12.65"},null,3,{"$f":"C33/120","v":0.025000000000000001},{"$nulls":4},"Bin9",{"$f":"MROUND($J$25+(0.9*$K$25),0.01)","v":15.35}]
[{"$f":"(J28+0.01)&\" \"&\"-\"&\" \"&J29","v":"12.66 - 13.19"},null,27,{"$f":"C34/120","v":0.22500000000000001},{"$nulls":4},"Bin10",{"$f":"K24","v":15.9}]
[{"$f":"(J29+0.01)&\" \"&\"-\"&\" \"&J30","v":"13.2 - 13.73"},null,12,{"$f":"C35/120","v":0.10000000000000001}]
[{"$f":"(J30+0.01)&\" \"&\"-\"&\" \"&J31","v":"13.74 - 14.27"},null,4,{"$f":"C36/120","v":0.033333333333333333},null,null,null,"CI-L",{"$f":"SMALL(A12:L21,1)","v":8},{"$f":"SMALL(A12:L21,7)","v":10.6}]
[{"$f":"(J31+0.01)&\" \"&\"-\"&\" \"&J32","v":"14.28 - 14.81"},null,2,{"$f":"C37/120","v":0.016666666666666666},null,null,null,"CI-U",{"$f":"SMALL(A12:L21,114)","v":15},{"$f":"SMALL(A12:L21,120)","v":30}]
[{"$f":"(J32+0.01)&\" \"&\"-\"&\" \"&J33","v":"14.82 - 15.35"},null,7,{"$f":"C38/120","v":0.058333333333333334},null,null,null,"CR",{"$f":"0.5*(J37-I37+J36-I36)/(K24-K23)","v":1.6296296296296298}]
[{"$f":"(J33+0.01)&\" \"&\"-\"&\" \"&J34","v":"15.36 - 15.9"},null,1,{"$f":"C39/120","v":0.0083333333333333332}]
[{"$f":"\">\"&\" \"&J34","v":"> 15.9"},null,2,{"$f":"C40/120","v":0.016666666666666666}]
[]
[]
[]
[null,null,"Confidence Intervals"]
[null,"Lower",{"$f":"I36","v":8},"to",{"$f":"J36","v":10.6}]
[null,"Upper",{"$f":"I37","v":15},"to",{"$f":"J37","v":30}]